Build AI Agents on Microsoft Dynamics 365 Business Central

Build intelligent AI Agents on top of Microsoft Dynamics 365 Business Central with Peliqan, the leading data foundation for the Agentic AI world.

Let AI do the work for you

Build AI Agents on top of Microsoft Dynamics 365 Business Central

Build intelligent AI Agents on top of Microsoft Dynamics 365 Business Central, with Peliqan’s AI data foundation:

  • Microsoft Dynamics 365 Business Central MCP Server
  • Microsoft Dynamics 365 Business Central in n8n AI Agents
  • Microsoft Dynamics 365 Business Central in Make
  • “Text to SQL” on Microsoft Dynamics 365 Business Central data
  • Microsoft Dynamics 365 Business Central RAG with out-of-the-box embeddings (vectors)
  • Microsoft Dynamics 365 Business Central Graph RAG
  • Query unified 360° data combining Microsoft Dynamics 365 Business Central and other data

Publish Data APIs

Microsoft Dynamics 365 Business Central MCP Server

Publish a Microsoft Dynamics 365 Business Central MCP Server to query data from Microsoft Dynamics 365 Business Central and to take actions in Microsoft Dynamics 365 Business Central such as doing updates and adding new data in Microsoft Dynamics 365 Business Central.

Peliqan n8n AI Agents RAG and Text To SQL

Microsoft Dynamics 365 Business Central in n8n

Build AI Chatbots and AI Agents in n8n that can perform “Text to SQL” to query Microsoft Dynamics 365 Business Central data and perform RAG and Graph RAG on information from Microsoft Dynamics 365 Business Central.

Let AI do the work for you

Implement a “Text to SQL” chatbot on Microsoft Dynamics 365 Business Central

Implement an AI Chatbot that can answer analytical data questions on Microsoft Dynamics 365 Business Central data using “Text to SQL”. 

Spreadsheet BI for business users

Implement a chatbot with RAG on Microsoft Dynamics 365 Business Central

Implement RAG (retrieval-augmented generation) on Microsoft Dynamics 365 Business Central data with an out-of-the-box vector store (embeddings) of all business entities and other information in Microsoft Dynamics 365 Business Central.

Combine Microsoft Dynamics 365 Business Central data with 250+ other sources and build 360° views

Combine data from Microsoft Dynamics 365 Business Central with data from 250+ other connectors, and build 360° views of business entities such as customers, leads, products, employees etc.

Feed unified 360° data models to your AI Agents with RAG and “Text to SQL”. Allow your AI Agents to access all business data in one uniform data model.

Prepare your Microsoft Dynamics 365 Business Central data for AI

Access, combine, and report on data from Microsoft Dynamics 365 Business Central and all your SaaS apps instantly.

Gain valuable insights by bringing all your business data together in one place within minutes.

Spreadsheet BI for business users

Security is our priority

SOC_2_Type_2

SOC 2 Type 2 validates our security controls, ensuring your data is protected by independently audited security measures.

iso2

ISO 27001 certification (in progress) ensures enterprise-grade information security, protecting your business with globally recognized standards.

GDPR-compliant

GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.

Peliqan Overview

Ready to get instant access to
all your company data ?

Frequently asked questions

Peliqan is an all-in-one data platform with 250+ data connectors (ERP, CRM, Accounting, ATS/HRM, cloud storage etc.) – including Microsoft Dynamics 365 Business Central – and a built-in data warehouse. Peliqan allows you to unleash, prepare and combine your Microsoft Dynamics 365 Business Central data for AI, including relational & non-relational data. Peliqan turns your Microsoft Dynamics 365 Business Central data into 360° views that can be used in AI Agents built in n8n, Make, langChain, langGraph or any other framework. Use Peliqan to create embeddings, store them in a vector store so that your AI chatbots can use RAG and Graph RAG, combined with Text-to-SQL for analytical reasoning. Peliqan is the only platform that allows your AI Agents to combine RAG and Text-to-SQL to apply deep reasoning on your Microsoft Dynamics 365 Business Central data. Use Peliqan to expose any Microsoft Dynamics 365 Business Central as an MCP server to query data and to take actions.

There are different ways to build an AI agent that can query data in Microsoft Dynamics 365 Business Central and take actions in Microsoft Dynamics 365 Business Central. For example you can build an AI agent in n8n and use Peliqan as the data foundation. Peliqan will sync your Microsoft Dynamics 365 Business Central data to its built-in data warehouse and allow the AI Agent to perform “Text to SQL” and RAG to answer questions and to perform reasoning on Microsoft Dynamics 365 Business Central data, combined with data from 250+ other sources.

First sign up for a free trial on Peliqan.io, next connect Microsoft Dynamics 365 Business Central in Peliqan. Once that is done, create an AI agent in n8n and use the Peliqan n8n node in your worflow. Add Peliqan as a “tool” to your AI Agent node, so that the AI agent can query your Microsoft Dynamics 365 Business Central data using Text to SQL.

There are different options to use RAG (retrieval augmented generation) in your AI Agent with Microsoft Dynamics 365 Business Central data. One option is to create a workflow in n8n that fetches all Microsoft Dynamics 365 Business Central data from Peliqan and stores it in Supabase as a vector store, with embeddings created using e.g. OpenAI.

In Peliqan, you can set up API endpoints and expose them as MCP Server. In the API endpoint handler script, you can configure actions to be taken in Microsoft Dynamics 365 Business Central such as querying data, doing lookups, adding new items or performing updates.

n8n is a great tool to build AI chatbots that use Text to SQL, to answer any analytical question on your Microsoft Dynamics 365 Business Central data. Any question will be converted by the AI agent into an SQL query, which is executed by Peliqan on the Microsoft Dynamics 365 Business Central data in the data warehouse.

In order to prepare your Microsoft Dynamics 365 Business Central data for RAG, you need to create embeddings and store them in a vector store. This can be done by creating a workflow in n8n that fetches all Microsoft Dynamics 365 Business Central data from Peliqan and stores it in Supabase as a vector store, with embeddings created using e.g. OpenAI.